/*
 Navicat MySQL Data Transfer

 Source Server         : local
 Source Server Version : 50717
 Source Host           : localhost
 Source Database       : weixin

 Target Server Version : 50717
 File Encoding         : utf-8

 Date: 10/10/2018 21:02:23 PM
*/

SET NAMES utf8;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
--  Table structure for `categorys`
-- ----------------------------
DROP TABLE IF EXISTS `categorys`;
CREATE TABLE `categorys` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `img` varchar(255) DEFAULT NULL,
  `pid` int(11) DEFAULT '0',
  `ds` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `categorys`
-- ----------------------------
BEGIN;
INSERT INTO `categorys` VALUES ('1', '热门推荐', 'imgs/cates/cate_1_1.png', '0', '2018-04-23 11:04:28'), ('2', '手机数码', 'imgs/cates/cate_1_2.png', '0', '2018-04-23 11:04:28'), ('3', '女装内衣', 'imgs/cates/cate_1_3.png', '0', '2018-04-23 11:04:28'), ('4', '男装内衣', 'imgs/cates/cate_1_4.png', '0', '2018-04-23 11:04:28'), ('5', '家用电器', 'imgs/cates/cate_1_5.png', '0', '2018-04-23 11:04:28'), ('6', '鞋靴箱包', 'imgs/cates/cate_1_6.png', '0', '2018-04-23 11:04:28'), ('7', '运动户外', 'imgs/cates/cate_1_7.png', '0', '2018-04-23 11:04:28'), ('8', '电脑办公', 'imgs/cates/cate_1_8.png', '0', '2018-04-23 11:04:28'), ('9', '个护化妆', 'imgs/cates/cate_1_9.png', '0', '2018-04-23 11:04:28'), ('10', '家具建材', 'imgs/cates/cate_1_10.png', '0', '2018-04-23 11:04:28'), ('11', '家居家纺', 'imgs/cates/cate_1_11.png', '0', '2018-04-23 11:04:28'), ('12', '母婴童装', 'imgs/cates/cate_1_12.png', '0', '2018-04-23 11:04:28');
COMMIT;

-- ----------------------------
--  Table structure for `commoncategory`
-- ----------------------------
DROP TABLE IF EXISTS `commoncategory`;
CREATE TABLE `commoncategory` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name_cn` varchar(255) DEFAULT NULL,
  `name_en` varchar(255) DEFAULT NULL,
  `common_tip` varchar(255) DEFAULT NULL,
  `ds` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `commoncategory`
-- ----------------------------
BEGIN;
INSERT INTO `commoncategory` VALUES ('1', '优选大牌', 'Brand', '精选一线大牌降价直降', '2018-04-22 12:24:06'), ('2', '优选热销', 'HOT', '最具人的TOP热销爆款', '2018-04-22 12:24:06'), ('3', '优选好货', 'GOOD', '大家都在买的高口碑好货', '2018-04-22 12:24:06');
COMMIT;

-- ----------------------------
--  Table structure for `commongoods`
-- ----------------------------
DROP TABLE IF EXISTS `commongoods`;
CREATE TABLE `commongoods` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `desci` varchar(255) DEFAULT NULL,
  `price` int(11) DEFAULT NULL,
  `tipstr` varchar(255) DEFAULT NULL,
  `content` varchar(255) DEFAULT NULL,
  `img` varchar(255) DEFAULT NULL,
  `ds` datetime DEFAULT NULL,
  `categoryid` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `commongoods`
-- ----------------------------
BEGIN;
INSERT INTO `commongoods` VALUES ('1', '美的电饭锅 具备各种功能 可以用来做柴火饭快煮等功能', '69', '满200件30;满100减10', '电子家具销量前二十', 'imgs/index/common_1.png', '2018-04-22 13:17:45', '1'), ('2', '苏泊尔（SUPOR)电磁炉 整板触控 SDHC8E15-210D电磁灶（赠汤锅+炒锅）', '72', '直接1元;9.8折', '母婴产品前三十', 'imgs/index/common_2.png', '2018-04-22 13:17:45', '1'), ('3', '美的电饭锅 具备各种功能 可以用来做柴火饭快煮等功能', '69', '满200件30;满100减10', '电子家具销量前二十', 'imgs/index/common_3.png', '2018-04-22 13:17:45', '1'), ('4', '美的电饭锅 具备各种功能 可以用来做柴火饭快煮等功能', '69', '满200件30;满100减10', '电子家具销量前二十', 'imgs/index/common_4.png', '2018-04-22 13:17:45', '1'), ('5', '美的电饭锅 具备各种功能 可以用来做柴火饭快煮等功能', '100', '满200件30;满100减10', '电子家具销量前二十', 'imgs/index/common_4.png', '2018-04-22 22:56:35', '2');
COMMIT;

-- ----------------------------
--  Table structure for `lunbo`
-- ----------------------------
DROP TABLE IF EXISTS `lunbo`;
CREATE TABLE `lunbo` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `imgUrl` varchar(255) DEFAULT NULL,
  `upTime` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `lunbo`
-- ----------------------------
BEGIN;
INSERT INTO `lunbo` VALUES ('1', 'http://img02.tooopen.com/images/20150928/tooopen_sy_143912755726.jpg', '2018-04-21 10:54:07'), ('2', 'http://img06.tooopen.com/images/20160818/tooopen_sy_175866434296.jpg', '2018-04-21 10:55:03'), ('3', 'http://img06.tooopen.com/images/20160818/tooopen_sy_175833047715.jpg', '2018-04-21 10:55:39'), ('4', 'http://img06.tooopen.com/images/20160818/tooopen_sy_175833047715.jpg', '2018-04-21 11:01:52');
COMMIT;

-- ----------------------------
--  Table structure for `renwu`
-- ----------------------------
DROP TABLE IF EXISTS `renwu`;
CREATE TABLE `renwu` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) DEFAULT NULL,
  `content` varchar(255) DEFAULT NULL,
  `img` varchar(255) DEFAULT NULL,
  `btn_text` varchar(255) DEFAULT NULL,
  `ds` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `renwu`
-- ----------------------------
BEGIN;
INSERT INTO `renwu` VALUES ('1', '每日任务', '今天没有签到，连续三天签到可以领取翻倍奖励~', 'imgs/index/renwu_1.png', '去签到', '2018-04-21 11:47:06'), ('2', '赢奖励', '邀请好友拆礼包，有机会获取50个商城豆~', 'imgs/index/renwu_2.png', '去领取', '2018-04-21 11:47:07');
COMMIT;

-- ----------------------------
--  Table structure for `tuijian`
-- ----------------------------
DROP TABLE IF EXISTS `tuijian`;
CREATE TABLE `tuijian` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `img` varchar(255) DEFAULT NULL,
  `title` varchar(255) DEFAULT NULL,
  `ds` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `tuijian`
-- ----------------------------
BEGIN;
INSERT INTO `tuijian` VALUES ('6', 'imgs/index/tuijian_1.png', '优惠券', '2018-04-21 11:10:53'), ('7', 'imgs/index/tuijian_2.png', '商城拼购', '2018-04-21 11:10:53'), ('8', 'imgs/index/tuijian_3.png', '找折扣', '2018-04-21 11:10:53'), ('9', 'imgs/index/tuijian_4.png', '挑选礼物', '2018-04-21 11:10:53'), ('10', 'imgs/index/tuijian_5.png', '定制频道', '2018-04-21 11:10:53');
COMMIT;

-- ----------------------------
--  Table structure for `wxusers`
-- ----------------------------
DROP TABLE IF EXISTS `wxusers`;
CREATE TABLE `wxusers` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `age` varchar(255) DEFAULT NULL,
  `sex` varchar(255) DEFAULT NULL,
  `desci` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `wxusers`
-- ----------------------------
BEGIN;
INSERT INTO `wxusers` VALUES ('1', '陈亮', '34', '男', '骚气'), ('2', '刘兴', '28', '男', '帅气');
COMMIT;

-- ----------------------------
--  Table structure for `xuanyou`
-- ----------------------------
DROP TABLE IF EXISTS `xuanyou`;
CREATE TABLE `xuanyou` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) DEFAULT NULL,
  `title_2` varchar(255) DEFAULT NULL,
  `img` varchar(255) DEFAULT NULL,
  `ds` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `xuanyou`
-- ----------------------------
BEGIN;
INSERT INTO `xuanyou` VALUES ('1', '珠宝馆', '满1000减200', 'imgs/index/xuanyou_1.png', '2018-04-21 12:04:20'), ('2', '医药健康馆', '满199减100', 'imgs/index/xuanyou_2.png', '2018-04-21 12:04:20'), ('3', '鞋子服饰', '满300减200', 'imgs/index/xuanyou_3.png', '2018-04-21 12:04:20'), ('4', '钟表馆', '满1000送礼物', 'imgs/index/xuanyou_4.png', '2018-04-21 12:04:20'), ('5', '生活超市', '全场8折', 'imgs/index/xuanyou_5.png', '2018-04-21 12:04:20'), ('6', '出行必备', '低至9.9', 'imgs/index/xuanyou_6.png', '2018-04-21 12:04:20'), ('7', '电子产品', '新品6.7折', 'imgs/index/xuanyou_7.png', '2018-04-21 12:04:20'), ('8', '小吃指南', '新鲜不断', 'imgs/index/xuanyou_8.png', '2018-04-21 12:04:20'), ('9', '热门设备', '加送保护套', 'imgs/index/xuanyou_9.png', '2018-04-21 12:04:20');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
